{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Data Entry","Total Storage Cost by Category","Depreciation"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":87,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Total Storage Cost by Category","index":2,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AHDB Potato Storage Cost Calculator "]
[]
[null,"User Guide"]
[]
[null,1,"Orange and Yellow Cells are for data entry."]
[]
[null,2,"Complete the only Orange cells to produce an 'Industry Costing' storage cost."]
[]
[null,null,"'My Data' will be populated by Industry data unless overwritten."]
[]
[null,3,"Complete the Yellow cells to produce a farm specific cost.  Please note:"]
[]
[null,null,"The graphical spread of 'My Data' costs is based on the Industry data."]
[]
[null,null,"Use the Depreciation worksheet to add capital investment."]
[]
[null,4,"The RAG (Red, Amber Green) score performance against the Industry Data."]
[]
[null,null,"Red  - 'My Data' storage cost more than 5% higher than Industry Data."]
[]
[null,null,"Amber -  'My Data' storage cost 0 - 5% higher than Industry Data."]
[]
[null,null,"Green - 'My Data' storage cost lower than Industry Data."]
[]
[null,5,"Reset Button will restore the standard settings (macros must be enabled on opening)."]
[]
[null,"ver June 2017"]

{"sheet":"Data Entry","index":1,"n_rows":128,"n_cols":62,"rows_kept":128,"cut":false,"hidden":false,"merged":[[5,5,5,31],[7,20,7,22],[7,17,7,19]]}
[{"$nulls":36},{"$f":"AK3","v":"Oct"},{"$f":"AL3","v":"Nov"},"Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug"]
[{"$nulls":29},"Select whether top graph displays",{"$nulls":5},"Months in store",1,2,3,4,5,6,7,8,9,10,11,12]
[1,{"$nulls":28}," 'Industry' or 'My Data'",{"$nulls":5},"Ex Field",{"$f":"I23","v":"Oct"},{"$f":"VLOOKUP(AK4+1,$V$58:$W$84,2,FALSE)","v":"Nov"},"Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"]
[2,{"$nulls":28},"My Data",{"$nulls":4},"Crop type drives Depreciation","Mth No.",{"$f":"VLOOKUP(AK3,$U$58:$V$84,2,FALSE)","v":3},{"$f":"AK4+1","v":4},{"$f":"AL4+1","v":5},6,7,8,9,10,11,12,13]
[3,{"$nulls":33},"Sale Price for Each period",{"$f":"I30","v":0},{"$f":"I31","v":0},{"$f":"I32","v":0},{"$f":"I33","v":0},{"$f":"I34","v":0},{"$f":"I35","v":0},{"$f":"I36","v":0},{"$f":"IF(ISBLANK($I$37),\"\",$I$37)","v":""},{"$f":"IF(ISBLANK($I$38),\"\",$I$38)","v":""},{"$f":"IF(ISBLANK($I$39),\"\",$I$39)","v":""},{"$f":"IF(ISBLANK($I$40),\"\",$I$40)","v":""},{"$f":"IF(ISBLANK($I$41),\"\",$I$41)","v":""}]
[4,{"$nulls":4},"AHDB Potato Storage Cost Calculator ",{"$nulls":28},"Margin compared with off field price",null,{"$f":"IF(AK$4>$C24,NA(),AK5-$AJ$5)","v":0},0,0,0,0,0,{"$f":"IF(OR(AQ$4>$C24,ISBLANK($I$37)),NA(),AQ5-$AJ$5)","v":{"$error":"#N/A"}},{"$f":"IF(OR(AR$4>$C24,ISBLANK($I$38)),NA(),AR5-$AJ$5)","v":{"$error":"#N/A"}},{"$f":"IF(OR(AS$4>$C24,ISBLANK($I$39)),NA(),AS5-$AJ$5)","v":{"$error":"#N/A"}},{"$f":"IF(OR(AT$4>$C24,ISBLANK($I$40)),NA(),AT5-$AJ$5)","v":{"$error":"#N/A"}},{"$f":"IF(OR(AU$4>$C24,ISBLANK($I$41)),NA(),AU5-$AJ$5)","v":{"$error":"#N/A"}}]
[5,{"$nulls":33},"ALL CELLS REFERENCE THIS NO.",20]
[6,{"$nulls":4},"Store Name",{"$nulls":6},"Cost before storage losses",{"$nulls":4},"Industry",null,null,"My Data"]
[7,{"$nulls":16},"Store ",null,null,"Store ",{"$nulls":13},"Industry Data","LAST MONTH",{"$f":"AK3","v":"Oct"},"Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug"]
[8,{"$nulls":4},"Crop Type",null,null,"Ware",null,null,null,"Energy",{"$nulls":4},"Total (£)","£T","p/kWh","Total (£)","£T","RAG",{"$nulls":11},"Labour/Machinery",null,{"$f":"IF(AK$4>$AJ$7,\"\",+AK127*(1+$AV$11))","v":3.4715625000000001},{"$f":"IF(AL$4>$AJ7,\"\",+AL127*(1+$AV$11))","v":3.8187187499999995},4.1658749999999998,4.51303125,4.8601874999999994,5.2073437499999997,5.5544999999999991,5.9016562499999985,6.2488124999999997,6.595968749999999,6.9431250000000002,"Inc over 2010"]
[9,{"$nulls":4},"Store Type",null,null,"Fridge",null,null,null,"Electricity",{"$nulls":4},{"$f":"IFERROR(S11*$I$16,\"\")","v":8280},{"$f":"IF(I9=\"Other\",\"\",IFERROR(HLOOKUP($I$24,$AI$3:$AU$103,A11,FALSE),\" \"))","v":8.2799999999999994},9,{"$f":"R11","v":8280},{"$f":"IF(ISBLANK(U11),0,U11/$I$16)","v":8.2799999999999994},{"$f":"IFERROR((V11-S11)/S11,\"\")","v":0},{"$nulls":11},"Energy",null,{"$f":"IF(AK$4>$AJ7,\"\",VLOOKUP($AJ$109,$AI$110:$AU$115,AK108,FALSE)*($T$11/100))","v":1.7999999999999998},3.42,4.8599999999999994,6.12,7.29,8.2799999999999994,9.18,9.99,10.709999999999999,11.52,{"$f":"IF(AU$4>$AJ7,\"\",VLOOKUP($AJ$109,$AI$110:$AU$115,AW108,FALSE)*($T$11/100))","v":12.42},0.05]
[10,{"$nulls":11},"Gas Heat",{"$nulls":8},{"$f":"IF(ISBLANK(U12),0,U12/$I$16)","v":0},{"$f":"IFERROR((V12-S12)/S12,\"\")","v":""},{"$nulls":11},"Store Hygiene/ Chemicals",null,{"$f":"IF(AK$4>$AJ7,\"\",0.2625)","v":0.26250000000000001},0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001]
[11,{"$nulls":4},"Box/Bulk",null,null,"Bulk",{"$nulls":25},"Sprout Suppressant",null,{"$f":"IF(AK$4>$AJ7,\"\",0)","v":0},{"$f":"IF(AL$4>$AJ7,\"\",0)","v":0},{"$f":"IF(AM$4>$AJ7,\"\",1.3)","v":1.3},{"$f":"IF(AN$4>$AJ7,\"\",1.3)","v":1.3},{"$f":"IF(AO$4>$AJ7,\"\",1.3)","v":1.3},{"$f":"IF(AP$4>$AJ7,\"\",2.6)","v":2.6},2.6,2.6,2.6,2.6,2.6]
[12,{"$nulls":4},"Ave Box Size (Fresh T)",null,null,1,null,null,null,"Variable Costs",{"$nulls":21},"Building Depn",null,{"$f":"IF(AK$4>$AJ7,\"\",IF($I$10=$N$58,AK121,IF($I$10=$N$59,AK122,IF($I$10=$N$60,AK120,0)))-AK15)","v":15.652000000000001},15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001]
[13,{"$nulls":4},"Boxes held (T if bulk)",null,null,1000,null,null,null,"Labour/Machinery",{"$nulls":4},{"$f":"IFERROR(S15*$I$16,\"\")","v":5207.34375},{"$f":"IF(I9=\"Other\",\"\",HLOOKUP($I$24,$AI$3:$AU$103,A10,FALSE))","v":5.2073437499999997},null,{"$f":"R15","v":5207.34375},{"$f":"IF(ISBLANK(U15),0,U15/$I$16)","v":5.2073437499999997},{"$f":"IFERROR((V15-S15)/S15,\"\")","v":0},{"$nulls":11},"Box/Equip Depn",null,{"$f":"IF(AK$4>$AJ7,\"\",IF($I$13=\"box\",5.52,2.52))","v":2.52},2.52,2.52,2.52,2.52,2.52,2.52,2.52,2.52,2.52,2.52]
[14,{"$nulls":4},"Tonnage Stored",null,null,{"$f":"IF(I13=R59,I15,I15*I14)","v":1000},null,null,null,"Third Party Handling",{"$nulls":8},0,{"$f":"IFERROR((V16-S16)/S16,\"\")","v":""},{"$nulls":11},"Total Depn",null,{"$f":"IF(AK$4>$AJ7,\"\",SUM(AK14:AK15))","v":18.172000000000001},18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,"Inc over 2010","discount from Box"]
[15,{"$nulls":11},"Store Hygiene",{"$nulls":4},{"$f":"IFERROR(S17*$I$16,\"\")","v":262.5},{"$f":"IF(I9=\"Other\",\"\",HLOOKUP($I$24,$AI$3:$AU$103,A12,FALSE))","v":0.26250000000000001},null,{"$f":"R17","v":262.5},0.26250000000000001,{"$f":"IFERROR((V17-S17)/S17,\"\")","v":0},{"$nulls":11},"Property Repairs",null,{"$f":"IF(AK$4>$AJ$7,\"\",IF($I$13=\"box\",+AK128*(1+$AV$17),+AK128*(1+$AV$17)-$AW$17))","v":0.72670000000000012},0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.03,2.25]
[16,{"$nulls":11},"Sprout Suppressant",{"$nulls":4},{"$f":"IFERROR(S18*$I$16,\"\")","v":2600},{"$f":"IF(I9=\"Other\",\"\",HLOOKUP($I$24,$AI$3:$AU$103,A13,FALSE))","v":2.6},null,{"$f":"R18","v":2600},2.6,{"$f":"IFERROR((V18-S18)/S18,\"\")","v":0},{"$nulls":11},"Finance",null,{"$f":"IF(AK$4>$AJ$7,\"\",AK26)","v":3.4020580416666673},3.4348304583333338,3.4919172500000006,3.5498517500000006,3.6170006250000006,3.7166638750000005,3.8014748333333337,3.892200166666667,3.9879398750000004,4.0937939583333343,4.2106624166666675]
[17,{"$nulls":4},"Ex Field Yield",null,null,45,"T/Ha",{"$nulls":24},"3rd Party Rent"]
[18,{"$nulls":11},"Fixed Costs",{"$nulls":21},"Total Storage Costs before losses",null,{"$f":"IF(AK$4>$C24,NA(),SUM(AK10:AK15,AK17:AK19))","v":27.834820541666669},29.834749208333335,32.978992250000005,34.644083000000002,36.228388125000002,38.965207625000005,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[19,{"$nulls":4},"Interest Rate",null,null,0.02,null,null,null,"Depreciation"]
[20,null,"mth ref",{"$nulls":11},"Building",null,null,{"$f":"IFERROR(S22*$I$16,\"\")","v":15652.000000000002},{"$f":"IF(I9=\"Other\",\"\",HLOOKUP($I$24,$AI$3:$AU$103,A14,FALSE))","v":15.652000000000001},null,{"$f":"IF(ISBLANK(V22),\"\",V22*$I$16)","v":15652.000000000002},{"$f":"IFERROR(IF(+Depreciation!H18<=0,S22,+Depreciation!H18),0)","v":15.652000000000001},{"$f":"IFERROR((V22-S22)/S22,\"\")","v":0}]
[21,null,{"$f":"VLOOKUP(I23,$U$58:$V$84,2,FALSE)","v":3},null,null,"Store Loading",null,null,"Oct","Months",{"$nulls":4},"Box & Fixed Equip.",null,null,{"$f":"IFERROR(S23*$I$16,\"\")","v":2520},{"$f":"IF(I9=\"Other\",\"\",HLOOKUP($I$24,$AI$3:$AU$103,A15,FALSE))","v":2.52},null,{"$f":"IF(ISBLANK(V23),\"\",V23*$I$16)","v":2520},{"$f":"IFERROR(IF(+Depreciation!H35+Depreciation!H53<=0,S23,+Depreciation!H19),0)","v":2.52},{"$f":"IFERROR((V23-S23)/S23,\"\")","v":0},{"$nulls":11},"Finance","Crop",{"$f":"IFERROR(AK5*AK2*($I$21/12),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[22,null,{"$f":"VLOOKUP(I24,$U$58:$V$84,2,FALSE)","v":8},null,null,"Store Outloading",null,null,"Mar",{"$f":"HLOOKUP(I24,AK1:AU3,2,FALSE)","v":6},null,null,"Property Repairs",{"$nulls":4},{"$f":"IFERROR(S24*$I$16,\"\")","v":726.70000000000016},{"$f":"IF(I9=\"Other\",\"\",HLOOKUP($I$24,$AI$3:$AU$103,A17,FALSE))","v":0.72670000000000012},null,{"$f":"R24","v":726.70000000000016},{"$f":"IF(ISBLANK(U24),0,U24/$I$16)","v":0.72670000000000012},{"$f":"IFERROR((V24-S24)/S24,\"\")","v":0},{"$nulls":12},"WC",{"$f":"SUM(AK10:AK13,AK10:AK13,AK17,AK19)*AK2*($I$21/12)","v":1.9658041666666667E-2},5.2430458333333325E-2,0.10951725000000001,0.16745175000000001,0.23460062500000003,0.33426387499999999,0.4190748333333334,0.50980016666666672,0.60553987500000006,0.71139395833333341,0.82826241666666689]
[23,{"$nulls":7},{"$f":"IF((C24-C23)>10,\"Error, Maximum Storage Period 11 Months\",\"\")","v":""},null,null,null," incl. Servicing & Box Repairs",{"$nulls":22},"Fixed",{"$f":"($S22*20*50/100*$I$21)+($S23*10*50/100*$I$21)","v":3.3824000000000005},3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005]
[24,{"$nulls":11},"3rd Party Rent",{"$nulls":8},{"$f":"IF(ISBLANK(U26),0,U26/$I$16)","v":0},{"$f":"IFERROR((V26-S26)/S26,\"\")","v":""},{"$nulls":12},"Total",{"$f":"SUM(AK23:AK25)","v":3.4020580416666673},{"$f":"SUM(AL23:AL25)","v":3.4348304583333338},3.4919172500000006,3.5498517500000006,3.6170006250000006,3.7166638750000005,3.8014748333333337,3.892200166666667,3.9879398750000004,4.0937939583333343,4.2106624166666675]
[25]
[26,{"$nulls":4}," Sale Price",null,"Timing","£T",null,null,null,"Finance Costs"]
[27,{"$nulls":13},"Crop",null,null,{"$f":"IFERROR(S29*$I$16,\"\")","v":0},{"$f":"IF(I9=\"Other\",\"\",HLOOKUP($I$24,$AI$3:$AU$103,A23,FALSE))","v":0},{"$nulls":15},"Grower Data","LAST MONTH",{"$f":"AK9","v":"Oct"},{"$f":"AL9","v":"Nov"},"Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug",null,"GROWER DATA PROPORTIONAL ANALYSIS",null,{"$f":"+AK29","v":"Oct"},{"$f":"+AL29","v":"Nov"},"Dec","Jan","Feb","Mar","Apr","May","Jun","Jul",{"$f":"+AU29","v":"Aug"}]
[28,{"$nulls":6},"Off Field",{"$nulls":6},"Overhead Costs*",null,null,{"$f":"IFERROR(S30*$I$16,\"\")","v":334.26387499999998},{"$f":"IF(I10=\"Other\",\"\",HLOOKUP($I$24,$AI$3:$AU$103,A24,FALSE))","v":0.33426387499999999},{"$nulls":15},"Labour/Machinery incl. 3rd Party Handling",null,{"$f":"+AY30","v":3.4715625000000001},{"$f":"+AZ30","v":3.8187187499999995},4.1658749999999998,4.51303125,4.8601874999999994,5.2073437499999997,0,0,0,0,0,null,"Labour/Machinery",null,{"$f":"IF(AK$4<=$C$24,AK10,0)","v":3.4715625000000001},{"$f":"IF(AL$4<=$C$24,AL10,0)","v":3.8187187499999995},4.1658749999999998,4.51303125,4.8601874999999994,5.2073437499999997,0,0,0,0,0,{"$f":"SUM(AY30:BI30)","v":26.036718749999999}]
[29,{"$nulls":6},{"$f":"AK3","v":"Oct"},{"$nulls":6},"Building/Fixed Plant",null,null,{"$f":"IFERROR(S31*$I$16,\"\")","v":3382.4000000000005},{"$f":"IF(I11=\"Other\",\"\",HLOOKUP($I$24,$AI$3:$AU$103,A25,FALSE))","v":3.3824000000000005},{"$nulls":15},"Energy",null,{"$f":"+AY31","v":1.7999999999999998},3.42,4.8599999999999994,6.12,7.29,8.2799999999999994,0,0,0,0,0,null,"Electricity",null,{"$f":"IF(AK$4<=$C$24,AK11,0)","v":1.7999999999999998},{"$f":"IF(AL$4<=$C$24,AL11,0)","v":3.42},4.8599999999999994,6.12,7.29,8.2799999999999994,0,0,0,0,0,{"$f":"SUM(AY31:BI31)","v":31.769999999999996}]
[30,{"$nulls":6},{"$f":"AL3","v":"Nov"},{"$nulls":6},"Total Finance",null,null,{"$f":"IFERROR(S32*$I$16,\"\")","v":3716.6638750000006},{"$f":"IF(I9=\"Other\",\"\",IFERROR(HLOOKUP($I$24,$AI$3:$AU$103,A26,FALSE),\" \"))","v":3.7166638750000005},null,{"$f":"R32","v":3716.6638750000006},{"$f":"IF(ISBLANK(U32),\"\",U32/$I$16)","v":3.7166638750000005},{"$f":"IFERROR((V32-S32)/S32,\"\")","v":0},{"$nulls":11},"Store Hygiene/ Chemicals",null,0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0,0,0,0,0,null,"Store Hygiene/ Chemicals",null,{"$f":"IF(AK$4<=$C$24,AK12,0)","v":0.26250000000000001},{"$f":"IF(AL$4<=$C$24,AL12,0)","v":0.26250000000000001},0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,0,0,0,0,0,1.575]
[31,{"$nulls":6},{"$f":"AM3","v":"Dec"},{"$nulls":26},"Sprout Suppressant",null,{"$f":"+AY33","v":0},0,1.3,1.3,1.3,2.6,0,0,0,0,0,null,"Sprout Suppressant",null,{"$f":"IF(AK$4<=$C$24,AK13,0)","v":0},{"$f":"IF(AL$4<=$C$24,AL13,0)","v":0},1.3,1.3,1.3,2.6,0,0,0,0,0,6.5]
[32,{"$nulls":6},{"$f":"AN3","v":"Jan"},{"$nulls":4},"Total Storage Cost: based on Fresh Tonnes",{"$nulls":21},"Building Depn",null,{"$f":"$V22","v":15.652000000000001},15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,15.652000000000001,null,"Building Depn",{"$nulls":12},0]
[33,{"$nulls":6},{"$f":"AO3","v":"Feb"},{"$nulls":4},"£ per Tonne Stored",{"$nulls":4},{"$f":"S35*$I$16","v":38965.207624999995},{"$f":"IFERROR(+S32+S24+S23+S22+S18+S17+S11+S15,0)","v":38.965207624999998},null,{"$f":"+U32+U24+U23+U22+U18+U17+U11+U15+U16+U26+U12","v":38965.207625000003},{"$f":"IF(ISBLANK(U35),\"\",U35/$I$16)","v":38.965207625000005},{"$f":"IFERROR((V35-S35)/S35,\"\")","v":1.8235312451003531E-16},{"$nulls":11},"Box/Equip Depn",null,{"$f":"$V23","v":2.52},2.52,2.52,2.52,2.52,2.52,2.52,2.52,2.52,2.52,2.52,null,"Box/Equip Depn",{"$nulls":12},0]
[34,{"$nulls":6},{"$f":"AP3","v":"Mar"},{"$nulls":4},{"$f":"\"Fresh Yield \"&J19","v":"Fresh Yield T/Ha"},{"$nulls":5},{"$f":"I19","v":45},null,null,{"$f":"+I19","v":45},{"$f":"IFERROR((V36-S36)/S36,\"\")","v":0},{"$nulls":11},"Total Depn",null,{"$f":"SUM(AK34:AK35)","v":18.172000000000001},{"$f":"SUM(AL34:AL35)","v":18.172000000000001},18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,null,"Total Depn",{"$nulls":12},0]
[35,{"$nulls":6},{"$f":"AQ3","v":"Apr"},{"$nulls":26},"Property Repairs",null,{"$f":"+$V$24","v":0.72670000000000012},{"$f":"+$V$24","v":0.72670000000000012},0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,null,"Property Repairs",null,{"$f":"IF(AK$4<=$C$24,AK17,0)","v":0.72670000000000012},{"$f":"IF(AL$4<=$C$24,AL17,0)","v":0.72670000000000012},0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,0,0,0,0,0,4.3602000000000007]
[36,{"$nulls":6},{"$f":"AR3","v":"May"},{"$nulls":4},"Calculated Storage Cost per Tonne Sold",{"$nulls":21},"Finance",null,{"$f":"IF(AK$4>$AJ$7,\"\",AK46)","v":3.4020580416666673},{"$f":"IF(AL$4>$AJ$7,\"\",AL46)","v":3.4348304583333338},3.4919172500000006,3.5498517500000006,3.6170006250000006,3.7166638750000005,3.390878166666667,3.3920893333333337,3.3933005000000005,3.3945116666666673,3.395722833333334,null,"Finance",null,{"$f":"IF(AK$4<=$C$24,AK18,0)","v":3.4020580416666673},{"$f":"IF(AL$4<=$C$24,AL18,0)","v":3.4348304583333338},3.4919172500000006,3.5498517500000006,3.6170006250000006,3.7166638750000005,0,0,0,0,0,21.212322000000004]
[37,{"$nulls":6},{"$f":"AS3","v":"Jun"},{"$nulls":4},"Estimated Storage Losses",{"$nulls":4},"£ Total","£T","%","£ Total","£T","%",{"$nulls":11},"3rd Party Rent",null,{"$f":"$V$26","v":0},{"$f":"$V$26","v":0},0,0,0,0,0,0,0,0,0,null,"3rd Party Rent",{"$nulls":12},0]
[38,{"$nulls":6},{"$f":"AT3","v":"Jul"},{"$nulls":4},"Rejection/Packout **",{"$nulls":4},{"$f":"S40*$I$16","v":0},{"$f":"$I$30*AV99","v":0},{"$f":"HLOOKUP($I$24,$AI$3:$AU$103,A99,FALSE)","v":5.5E-2},{"$f":"V40*$I$16","v":0},{"$f":"$I$30*W40","v":0},{"$f":"T40","v":5.5E-2},{"$nulls":11},"Total Storage Costs before losses",null,{"$f":"IF(AK$4>$C24,NA(),SUM(AK30:AK35,AK37:AK39))","v":27.834820541666669},{"$f":"IF(AL$4>$C24,NA(),SUM(AL30:AL35,AL37:AL39))","v":29.834749208333335},32.978992250000005,34.644083000000002,36.228388125000002,38.965207625000005,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Total Storage Costs before losses",{"$nulls":12},0]
[39,{"$nulls":6},{"$f":"AU3","v":"Aug"},{"$nulls":4},"W/Loss, Storage & Grading",{"$nulls":4},0,{"$f":"$I$30*AV100","v":0},{"$f":"HLOOKUP($I$24,$AI$3:$AU$103,A100,FALSE)","v":0.08},0,{"$f":"$I$30*W41","v":0},{"$f":"T41","v":0.08},{"$nulls":38},0]
[40,{"$nulls":11},"Contract Allowances",{"$nulls":5},{"$f":"$I$30*T42","v":0},-0.05,null,{"$f":"$I$30*W42","v":0},{"$f":"T42","v":-0.05}]
[41,{"$nulls":11},"Total",{"$nulls":4},0,{"$f":"SUM(S40:S42)","v":0},null,0,{"$f":"IF(SUM(V40:V42)<0,0,SUM(V40:V42))","v":0},{"$nulls":12},"Finance","Crop",{"$f":"IFERROR(AK5*AK2*($I$21/12),0)","v":0},{"$f":"IFERROR(AL5*AL2*($I$21/12),0)","v":0},0,0,0,0,0,0,0,0,0]
[42,{"$nulls":34},"WC",{"$f":"SUM(AK30:AK33,AK30:AK33,AK37,AK39)*AK2*($I$21/12)","v":1.9658041666666667E-2},{"$f":"SUM(AL30:AL33,AL30:AL33,AL37,AL39)*AL2*($I$21/12)","v":5.2430458333333325E-2},0.10951725000000001,0.16745175000000001,0.23460062500000003,0.33426387499999999,8.4781666666666686E-3,9.6893333333333363E-3,1.0900500000000002E-2,1.211166666666667E-2,1.3322833333333336E-2]
[43,{"$nulls":11},"Total Storage Cost: based on Ex-store Tonnes",{"$nulls":11},"See separate graph for breakdown by category",{"$nulls":10},"Fixed",{"$f":"($S22*20*50/100*$I$21)+($S23*10*50/100*$I$21)","v":3.3824000000000005},3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005,3.3824000000000005]
[44,{"$nulls":11},"£ per tonne Sold",{"$nulls":4},{"$f":"S46*$I$16","v":38965.207624999995},{"$f":"S35+S43","v":38.965207624999998},null,null,{"$f":"V35+V43","v":38.965207625000005},{"$f":"IFERROR((V46-S46)/S46,\"\")","v":1.8235312451003531E-16},{"$nulls":12},"Total",{"$f":"SUM(AK43:AK45)","v":3.4020580416666673},{"$f":"SUM(AL43:AL45)","v":3.4348304583333338},3.4919172500000006,3.5498517500000006,3.6170006250000006,3.7166638750000005,3.390878166666667,3.3920893333333337,3.3933005000000005,3.3945116666666673,3.395722833333334]
[45,{"$nulls":11},{"$f":"\"Sold Tonnes \"&J19","v":"Sold Tonnes T/Ha"},{"$nulls":5},{"$f":"I19-((T40+T41+T42)*I19)","v":41.174999999999997},null,null,{"$f":"I19-((W40+W41+W42)*I19)","v":41.174999999999997},0]
[46,{"$nulls":33},"BAR CHART SOURCE DATA -",{"$f":"+AD4","v":"My Data"}]
[47,{"$nulls":11},"* excluding depreciation",{"$nulls":21},"Total Storage Cost Graph (table created so that if there were missing elements of data, the graph would not function)"]
[48,{"$nulls":11},"**over and above contract allowance",{"$nulls":11},"Energy usage figures based on AHDB Potatoes Farm Energy Project (2011)",{"$nulls":9},"Labour/Machinery",null,{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AK$20),NA(),AK10),IF(ISERROR(AK$40),NA(),AK30))","v":3.4715625000000001},{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AL$20),NA(),AL10),IF(ISERROR(AL$40),NA(),AL30))","v":3.8187187499999995},4.1658749999999998,4.51303125,4.8601874999999994,5.2073437499999997,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[49,{"$nulls":33},"Energy",null,{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AK$20),NA(),AK11),IF(ISERROR(AK$40),NA(),AK31))","v":1.7999999999999998},{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AL$20),NA(),AL11),IF(ISERROR(AL$40),NA(),AL31))","v":3.42},4.8599999999999994,6.12,7.29,8.2799999999999994,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[50,{"$nulls":33},"Store Hygiene/ Chemicals",null,{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AK$20),NA(),AK12),IF(ISERROR(AK$40),NA(),AK32))","v":0.26250000000000001},{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AL$20),NA(),AL12),IF(ISERROR(AL$40),NA(),AL32))","v":0.26250000000000001},0.26250000000000001,0.26250000000000001,0.26250000000000001,0.26250000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[51,{"$nulls":33},"Sprout Suppressant",null,{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AK$20),NA(),AK13),IF(ISERROR(AK$40),NA(),AK33))","v":0},{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AL$20),NA(),AL13),IF(ISERROR(AL$40),NA(),AL33))","v":0},1.3,1.3,1.3,2.6,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[52,{"$nulls":33},"Total Depn",null,{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AK$20),NA(),AK16),IF(ISERROR(AK$40),NA(),AK36))","v":18.172000000000001},{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AL$20),NA(),AL16),IF(ISERROR(AL$40),NA(),AL36))","v":18.172000000000001},18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[53,{"$nulls":33},"Property Repairs",null,{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AK$20),NA(),AK17),IF(ISERROR(AK$40),NA(),AK37))","v":0.72670000000000012},{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AL$20),NA(),AL17),IF(ISERROR(AL$40),NA(),AL37))","v":0.72670000000000012},0.72670000000000012,0.72670000000000012,0.72670000000000012,0.72670000000000012,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[54,{"$nulls":4},"PLEASE ENABLE MACROS",{"$nulls":28},"Finance",null,{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AK$20),NA(),AK18),IF(ISERROR(AK$40),NA(),AK38))","v":3.4020580416666673},{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AL$20),NA(),AL18),IF(ISERROR(AL$40),NA(),AL38))","v":3.4348304583333338},3.4919172500000006,3.5498517500000006,3.6170006250000006,3.7166638750000005,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[55,"LOOK UP TABLES",{"$nulls":16},"loading",null,"spread",{"$nulls":4},"RESET FORM",null,null,null,"box size",{"$nulls":4},"3rd Party Rent",null,{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AK$20),NA(),AK19),IF(ISERROR(AK$40),NA(),AK39))","v":0},{"$f":"IF($AD$4=\"Industry\",IF(ISERROR(AL$20),NA(),AL19),IF(ISERROR(AL$40),NA(),AL39))","v":0},0,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[56,{"$nulls":8},"Industry",null,null,1,"Ware",null,"Potatoes",null,"Box","Aug",null,"Aug",1,"Aug",{"$nulls":13},{"$f":"SUM(AK50:AK57)","v":27.834820541666669},{"$f":"SUM(AL50:AL57)","v":29.834749208333335},32.978992250000005,34.644083000000002,36.228388125000002,38.965207625000005,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[57,"Ambient",{"$nulls":7},"My Data",null,null,2,"Processing",null,"Other",null,"Bulk","Sep",null,"Sep",2,"Sep",null,null,"Electricity Price",null,12,null,1]
[58,"Fridge",{"$nulls":10},3,"Seed",{"$nulls":4},"Oct",null,"Oct",3,"Oct",null,null,"First Storage Month",null,"Oct",null,1.1000000000000001]
[59,{"$nulls":11},4,{"$nulls":5},"Nov",null,"Nov",4,"Nov",null,null,"Last Storage Month",null,"Mar",null,1.25]
[60,{"$nulls":11},5,{"$nulls":5},"Dec",null,"Dec",5,"Dec",null,null,"Store Suppressant",null,{"$f":"$H$66*$G$66","v":0},1,1.5]
[61,{"$nulls":11},6,{"$nulls":5},"Jan",null,"Jan",6,"Jan",{"$nulls":4},{"$f":"$H$67*$G$67","v":0},2,2]
[62,{"$nulls":4},"Manual Sprout Suppressant costings",{"$nulls":6},7,{"$nulls":5},"Feb",null,"Feb",7,"Feb",{"$nulls":4},{"$f":"$H$68*$G$68","v":0},3,2.25]
[63,{"$nulls":5},"No of Apps","Cost/App (£/T)","Total £/T",null,null,null,8,{"$nulls":5},"Mar",null,"Mar",8,"Mar",{"$nulls":4},{"$f":"$H$69*$G$69","v":0},4,2.5]
[64,{"$nulls":4},"CIPC",null,null,{"$f":"+H66*G66","v":0},null,null,null,9,{"$nulls":5},"Apr",null,"Apr",9,"Apr"]
[65,{"$nulls":4},"Ethylene",null,null,{"$f":"+H67*G67","v":0},null,null,null,10,{"$nulls":5},"May",null,"May",10,"May",null,null,"RESET BOX"]
[66,{"$nulls":4},"Mint Oil",null,null,{"$f":"+H68*G68","v":0},null,null,null,11,{"$nulls":5},"Jun",null,"Jun",11,"Jun"]
[67,{"$nulls":4},"Other",null,null,{"$f":"+H69*G69","v":0},null,null,null,12,{"$nulls":5},"Jul",null,"Jul",12,"Jul",null,null,"to put electricity price back to standard, relink Depreciation, "]
[68,{"$nulls":19},"Aug",13,"Aug"]
[69,{"$nulls":19},"Sep",14,"Sep",null,null,"standardise storage period from Oct to Mar, reset store suppressant"]
[70,{"$nulls":19},"Oct",15,"Oct"]
[71,{"$nulls":19},"Nov",16,"Nov",{"$nulls":11},"LINE GRAPH SOURCE DATA"]
[72,{"$nulls":4},"MAKE A COPY OF THIS TAB (& THE DEPRECIATION ONE) & RESET THE FORM",{"$nulls":14},"Dec",17,"Dec",{"$nulls":11},"Margin compared with off field price",null,{"$f":"AK6","v":0},{"$f":"AL6","v":0},0,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[73,{"$nulls":19},"Jan",18,"Jan",{"$nulls":11},"Total Storage Costs before losses",null,{"$f":"IF($AD$4=\"Automatic\",AK20,AK40)","v":27.834820541666669},29.834749208333335,32.978992250000005,34.644083000000002,36.228388125000002,38.965207625000005,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[74,{"$nulls":19},"Feb",19,"Feb",{"$nulls":11},"Total Storage Costs after losses & allowances",null,{"$f":"IF($AD$4=\"Automatic\",AK105,AK$106)","v":27.834820541666669},29.834749208333335,32.978992250000005,34.644083000000002,36.228388125000002,38.965207625000005,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[75,{"$nulls":19},"Mar",20,"Mar"]
[76,{"$nulls":19},"Apr",21,"Apr"]
[77,{"$nulls":4},"T/Ha",{"$nulls":14},"May",22,"May",{"$nulls":11},"LINE CHART TITLE",null,{"$f":"\"Margin compared with Storage Cost £T \"&\"(\"&AD4&\")\"","v":"Margin compared with Storage Cost £T (My Data)"}]
[78,{"$nulls":4},"T/Ac",{"$nulls":14},"Jun",23,"Jun",{"$nulls":11},"BAR CHART TITLE",null,{"$f":"\"Total Storage Cost before losses £T \"&\"(\"&AD4&\")\"","v":"Total Storage Cost before losses £T (My Data)"}]
[79,{"$nulls":19},"Jul",24,"Jul"]
[80,{"$nulls":19},"Aug",25,"Aug"]
[81,{"$nulls":19},"Sep",26,"Sep"]
[82,{"$nulls":19},"Oct",27,"Oct"]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95,{"$nulls":33},"Details for Fresh/Sold Yield Losses Graph"]
[96,{"$nulls":35},1,2,3,4,5,6,7,8,9,10,11]
[97,{"$nulls":33},"Losses from Rejection/Packout",null,0.03,3.5000000000000003E-2,0.04,4.4999999999999998E-2,0.05,5.5E-2,0.06,6.5000000000000002E-2,7.0000000000000007E-2,7.4999999999999997E-2,0.08,{"$f":"HLOOKUP($I$24,$AI$3:$AU$103,A99,FALSE)","v":5.5E-2}]
[98,{"$nulls":33},"Storage and Grading Out losses",null,0.03,0.04,0.05,0.06,7.0000000000000007E-2,0.08,0.09,0.1,0.11,0.12,0.13,{"$f":"HLOOKUP($I$24,$AI$3:$AU$103,A100,FALSE)","v":0.08}]
[99,{"$nulls":38},"was",0.09,0.11,0.13,0.15,0.17,0.19,0.21]
[100,{"$nulls":33},"Total of Grading out and Rej/Packout",null,{"$f":"SUM(AK99:AK100)","v":0.06},7.5000000000000011E-2,0.09,0.105,0.12000000000000001,0.13500000000000001,0.15,0.16500000000000001,0.18,0.19500000000000001,0.21000000000000002,0.13500000000000001]
[101,{"$nulls":33},"Cost £T of losses",null,{"$f":"AK102*$I$30","v":0},0,0,0,0,0,0,0,0,0,0]
[102]
[103,{"$nulls":32},"INDUSTRY","Total Storage Costs after losses & allowances",null,{"$f":"IF(AK$4>$C24,NA(),AK103+AK20+$S$42)","v":27.834820541666669},29.834749208333335,32.978992250000005,34.644083000000002,36.228388125000002,38.965207625000005,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[104,{"$nulls":32},"MY DATA","Total Storage Costs after losses & allowances",null,{"$f":"IF(AK$4>$C24,NA(),AK103+AK40+$V$42)","v":27.834820541666669},29.834749208333335,32.978992250000005,34.644083000000002,36.228388125000002,38.965207625000005,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[105]
[106,{"$nulls":33},1,2,3,4,5,6,7,8,9,10,11,12,null,null,13]
[107,{"$nulls":33},"kwh per tonne (culmulative)",{"$f":"I10&\" \"&I11","v":"Ware Fridge"}]
[108,{"$nulls":33},"Seed Ambient"]
[109,{"$nulls":33},"Seed Fridge",null,16,30,42,51.906419753086418,60.906419753086418,69.906419753086425]
[110,{"$nulls":33},"Ware Ambient",null,9,16,21,25,28,31,33,35,37,39,41]
[111,{"$nulls":33},"Ware Fridge",null,20,38,54,68,81,92,102,111,119,128,138]
[112,{"$nulls":33},"Processing Ambient",null,9,16,21,25,28,31,33,35,37,39,41]
[113,{"$nulls":33},"Processing Fridge",null,12,20,28,35,40,44,47,50,53,56,60]
[114,{"$nulls":33},"Months in Store",null,1,2,3,4,5,6,7,8,9,10]
[115,{"$nulls":33},"ELECTRICITY USAGE CARRIED FORWARD TO ELECTRICITY PAGE"]
[116,{"$nulls":33},"Electricity",null,{"$f":"IF(AK$4>$AJ7,\"\",VLOOKUP($AJ$109,$AI$110:$AU$115,AK108,FALSE))","v":20},38,54,68,81,92,102,111,119,128,{"$error":"#VALUE!"}]
[117,{"$nulls":33},"Depreciation - Automatic",null,null,"need to show workings??"]
[118,{"$nulls":33},"Seed - refrig",null,{"$f":"16.52*1.1","v":18.172000000000001},{"$f":"16.52*1.1","v":18.172000000000001},18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,"increased by 10%"]
[119,{"$nulls":33},"Ware - refirg",null,{"$f":"16.52*1.1","v":18.172000000000001},18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,"increased by 10%"]
[120,{"$nulls":33},"Processing refrig",null,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,18.172000000000001,"increased by 10%"]
[121]
[]
[]
[]
[{"$nulls":34},"Labour/Machinery (2010)",null,3.3062499999999999,3.6368749999999994,3.9674999999999994,4.2981249999999998,4.6287499999999993,4.9593749999999996,5.2899999999999991,5.6206249999999986,5.951249999999999,6.2818749999999985,6.6124999999999998]
[{"$nulls":34},"Property Repairs (2010)",null,2.89,2.89,2.89,2.89,2.89,2.89,2.89,2.89,2.89,2.89,2.89]

{"sheet":"Depreciation","index":3,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,8,3,9],[19,8,19,9]]}
["Depreciation"]
["Building, Machinery and Box Depreciation",null,null,"Store Capacity",null,{"$f":"'Data Entry'!I16","v":1000},"Tonnes"]
["Current Year",2017]
["Descriptions","Purchase Price/Value (£)","Year Purchased/Valued","Depreciation\nRate (years) Straight line","Year End\nValue (£)",null,"Current Year\nDepreciation (£)","Depn./Tonne (£)","not to be shown"]
["Building"]
[{"$nulls":6},{"$f":"IF(I6<0,J6,0)","v":0},{"$f":"IFERROR(G6/$F$2,0)","v":0},{"$f":"$B$3-(C6+DefProCalBoxRefDep1)","v":2017},{"$f":"B6/DefProCalBoxRefDep1","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"IF(I7<0,J7,0)","v":0},{"$f":"IFERROR(G7/$F$2,0)","v":0},{"$f":"$B$3-(C7+DefProCalBoxRefDep2)","v":2017},{"$f":"B7/DefProCalBoxRefDep2","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},0,0,{"$f":"$B$3-(C8+DefProCalBoxRefDep3)","v":2017},{"$f":"B8/DefProCalBoxRefDep3","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},0,0,{"$f":"$B$3-(C9+DefProCalBoxRefDep4)","v":2017},{"$f":"B9/DefProCalBoxRefDep4","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},0,0,{"$f":"$B$3-(C10+DefProCalBoxRefDep5)","v":2017},{"$f":"B10/DefProCalBoxRefDep5","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},0,0,{"$f":"$B$3-(C11+DefProCalBoxRefDep6)","v":2017},{"$f":"B11/DefProCalBoxRefDep6","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},0,0,{"$f":"$B$3-(C12+DefProCalBoxRefDep7)","v":2017},{"$f":"B12/DefProCalBoxRefDep7","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},0,0,{"$f":"$B$3-(C13+DefProCalBoxRefDep8)","v":2017},{"$f":"B13/DefProCalBoxRefDep8","v":{"$error":"#DIV/0!"}}]
["If grant funding has been received, the benefit should be entered below (as negative)",{"$nulls":5},0,0,{"$f":"$B$3-(C14+DefProCalBoxRefDep9)","v":2017},{"$f":"B14/DefProCalBoxRefDep9","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},0,0,{"$f":"$B$3-(C15+DefProCalBoxRefDep10)","v":2017},{"$f":"B15/DefProCalBoxRefDep10","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},0,0,{"$f":"$B$3-(C16+DefProCalBoxRefDep11)","v":2017},{"$f":"B16/DefProCalBoxRefDep11","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},0,0,{"$f":"$B$3-(C17+DefProCalBoxRefDep12)","v":2017},{"$f":"B17/DefProCalBoxRefDep12","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"Total Depn.",{"$f":"SUM(G6:G17)","v":0},0]
[]
["Descriptions","Purchase Price/Value (£)","Year Purchased/Valued","Depreciation\nRate % (Reducing Balance)","Year End\nValue (£)","Proportion to be charged","Current Year\nDepreciation (£)","Depn./Tonne (£)","not to be shown"]
["Fixed Equipment / Machinery / Invertors / CIPC Stewardship Costs"]
[{"$nulls":4},{"$f":"+B22*(1-D22)^(+B$3-C22+1)","v":0},1,{"$f":"(+(B22*(1-D22)^(+B$3-C22))*D22)*F22","v":0},{"$f":"IFERROR(G22/$F$2,0)","v":0}]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":5},"Total Depn.",{"$f":"SUM(G22:G34)","v":0},0]
["Boxes"]
[{"$nulls":4},0,1,0,{"$f":"IFERROR(G37/$F$2,0)","v":0}]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,1,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
[{"$nulls":4},0,null,0,0]
["Total",{"$f":"SUM(B5:B52)","v":0},null,null,null,"Total Depn.",{"$f":"SUM(G37:G52)","v":0},0]